using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;


public partial class StoredProcedures
{
    [Microsoft.SqlServer.Server.SqlProcedure(Name="uspincrementProductPrices")]
    public static int incrementProductPrices()
    {
        // Put your code here
        int rowsAffected = 0;
        using (SqlConnection conn = new SqlConnection("context connection = true"))
        {
            conn.Open();
            string sql = "UPDATE Production.Product SET ListPrice=ListPrice+1";
            using (SqlCommand cmd = new SqlCommand(sql,conn))
            {
                cmd.CommandType = CommandType.Text;
                rowsAffected = cmd.ExecuteNonQuery();
            }
        }
        return rowsAffected;
    }
};
